Quality Report City Hour

Dataset statistics

Number of variables	16
Number of observations	707875
Missing cells	2515685
Missing cells (%)	22.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	86.4 MiB
Average record size in memory	128.0 B

Variable types

Categorical	2
DateTime	1
Numeric	13

Alerts

`AQI` is highly overall correlated with `PM10` and 1 other fields	High correlation
`Benzene` is highly overall correlated with `Toluene` and 1 other fields	High correlation
`NO` is highly overall correlated with `NOx`	High correlation
`NO2` is highly overall correlated with `NOx` and 1 other fields	High correlation
`NOx` is highly overall correlated with `NO` and 2 other fields	High correlation
`PM10` is highly overall correlated with `AQI` and 3 other fields	High correlation
`PM2.5` is highly overall correlated with `AQI` and 1 other fields	High correlation
`Toluene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`PM2.5` has 145088 (20.5%) missing values	Missing
`PM10` has 296737 (41.9%) missing values	Missing
`NO` has 116632 (16.5%) missing values	Missing
`NO2` has 117122 (16.5%) missing values	Missing
`NOx` has 123224 (17.4%) missing values	Missing
`NH3` has 272542 (38.5%) missing values	Missing
`CO` has 86517 (12.2%) missing values	Missing
`SO2` has 130373 (18.4%) missing values	Missing
`O3` has 129208 (18.3%) missing values	Missing
`Benzene` has 163646 (23.1%) missing values	Missing
`Toluene` has 220607 (31.2%) missing values	Missing
`Xylene` has 455829 (64.4%) missing values	Missing
`AQI` has 129080 (18.2%) missing values	Missing
`AQI_Bucket` has 129080 (18.2%) missing values	Missing
`CO` is highly skewed (γ1 = 20.85295945)	Skewed
`Benzene` is highly skewed (γ1 = 22.51160265)	Skewed
`NOx` has 19811 (2.8%) zeros	Zeros
`CO` has 66088 (9.3%) zeros	Zeros
`Benzene` has 118727 (16.8%) zeros	Zeros
`Toluene` has 89705 (12.7%) zeros	Zeros
`Xylene` has 49350 (7.0%) zeros	Zeros

Reproduction

Analysis started	2024-12-30 23:46:35.342403
Analysis finished	2024-12-30 23:47:30.462311
Duration	55.12 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

City
Categorical

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 MiB

Ahmedabad	48192
Bengaluru	48192
Chennai	48192
Mumbai	48192
Lucknow	48192
Other values (21)	466915

Length

Max length	18
Median length	12
Mean length	8.2754724
Min length	5

Characters and Unicode

Total characters	5858000
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ahmedabad
2nd row	Ahmedabad
3rd row	Ahmedabad
4th row	Ahmedabad
5th row	Ahmedabad

Common Values

Value	Count	Frequency (%)
Ahmedabad	48192	6.8%
Bengaluru	48192	6.8%
Chennai	48192	6.8%
Mumbai	48192	6.8%
Lucknow	48192	6.8%
Delhi	48192	6.8%
Hyderabad	48107	6.8%
Patna	44554	6.3%
Gurugram	40258	5.7%
Visakhapatnam	35053	5.0%
Other values (16)	250751	35.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ahmedabad	48192	6.8%
bengaluru	48192	6.8%
chennai	48192	6.8%
mumbai	48192	6.8%
lucknow	48192	6.8%
delhi	48192	6.8%
hyderabad	48107	6.8%
patna	44554	6.3%
gurugram	40258	5.7%
visakhapatnam	35053	5.0%
Other values (16)	250751	35.4%

Most occurring characters

Value	Count	Frequency (%)
a	1109817	18.9%
r	504103	8.6%
u	369145	6.3%
n	366662	6.3%
h	327804	5.6%
i	327468	5.6%
e	272265	4.6%
m	263480	4.5%
d	199861	3.4%
t	199045	3.4%
Other values (28)	1918350	32.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5858000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1109817	18.9%
r	504103	8.6%
u	369145	6.3%
n	366662	6.3%
h	327804	5.6%
i	327468	5.6%
e	272265	4.6%
m	263480	4.5%
d	199861	3.4%
t	199045	3.4%
Other values (28)	1918350	32.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5858000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1109817	18.9%
r	504103	8.6%
u	369145	6.3%
n	366662	6.3%
h	327804	5.6%
i	327468	5.6%
e	272265	4.6%
m	263480	4.5%
d	199861	3.4%
t	199045	3.4%
Other values (28)	1918350	32.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5858000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1109817	18.9%
r	504103	8.6%
u	369145	6.3%
n	366662	6.3%
h	327804	5.6%
i	327468	5.6%
e	272265	4.6%
m	263480	4.5%
d	199861	3.4%
t	199045	3.4%
Other values (28)	1918350	32.7%

Datetime
Date

Distinct	48192
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Memory size	5.4 MiB

Minimum	2015-01-01 01:00:00
Maximum	2020-07-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

PM2.5
Real number (ℝ)

High correlation Missing

Distinct	34105
Distinct (%)	6.1%
Missing	145088
Missing (%)	20.5%
Infinite	0
Infinite (%)	0.0%
Mean	67.622994

Minimum	0.01
Maximum	999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	10.5
Q1	26.2
median	46.42
Q3	79.49
95-th percentile	201.08
Maximum	999.99
Range	999.98
Interquartile range (IQR)	53.29

Descriptive statistics

Standard deviation	74.730496
Coefficient of variation (CV)	1.1051048
Kurtosis	32.710409
Mean	67.622994
Median Absolute Deviation (MAD)	23.96
Skewness	4.3051943
Sum	38057342
Variance	5584.647
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56	1679	0.2%
11	1050	0.1%
27	936	0.1%
15	929	0.1%
24	885	0.1%
21	875	0.1%
28	853	0.1%
17	852	0.1%
29	842	0.1%
22	841	0.1%
Other values (34095)	553045	78.1%
(Missing)	145088	20.5%

Value	Count	Frequency (%)
0.01	6	< 0.1%
0.02	14	< 0.1%
0.03	11	< 0.1%
0.04	14	< 0.1%
0.05	11	< 0.1%
0.06	6	< 0.1%
0.07	15	< 0.1%
0.08	9	< 0.1%
0.09	17	< 0.1%
0.1	16	< 0.1%

Value	Count	Frequency (%)
999.99	193	< 0.1%
997.93	1	< 0.1%
996.97	1	< 0.1%
995	75	< 0.1%
994.78	1	< 0.1%
994.58	1	< 0.1%
994	1	< 0.1%
992.16	1	< 0.1%
991.2	1	< 0.1%
986	1	< 0.1%

PM10
Real number (ℝ)

High correlation Missing

Distinct	45327
Distinct (%)	11.0%
Missing	296737
Missing (%)	41.9%
Infinite	0
Infinite (%)	0.0%
Mean	119.0758

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	21.53
Q1	52.38
median	91.5
Q3	147.52
95-th percentile	326.64
Maximum	1000
Range	999.99
Interquartile range (IQR)	95.14

Descriptive statistics

Standard deviation	104.22475
Coefficient of variation (CV)	0.87528069
Kurtosis	9.6406278
Mean	119.0758
Median Absolute Deviation (MAD)	44.26
Skewness	2.5086698
Sum	48956588
Variance	10862.799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	3432	0.5%
38	407	0.1%
36	382	0.1%
27	373	0.1%
44	369	0.1%
48	359	0.1%
31	359	0.1%
40	357	0.1%
42	342	< 0.1%
59	342	< 0.1%
Other values (45317)	404416	57.1%
(Missing)	296737	41.9%

Value	Count	Frequency (%)
0.01	15	< 0.1%
0.02	19	< 0.1%
0.03	28	< 0.1%
0.04	24	< 0.1%
0.05	14	< 0.1%
0.06	23	< 0.1%
0.07	18	< 0.1%
0.08	18	< 0.1%
0.09	17	< 0.1%
0.1	37	< 0.1%

Value	Count	Frequency (%)
1000	57	< 0.1%
999.99	41	< 0.1%
999.75	1	< 0.1%
998.19	1	< 0.1%
998.1	1	< 0.1%
997.26	1	< 0.1%
995.23	1	< 0.1%
993.1	1	< 0.1%
991.07	1	< 0.1%
991.02	1	< 0.1%

NO
Real number (ℝ)

High correlation Missing

Distinct	19887
Distinct (%)	3.4%
Missing	116632
Missing (%)	16.5%
Infinite	0
Infinite (%)	0.0%
Mean	17.421755

Minimum	0.01
Maximum	499.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	1.14
Q1	3.84
median	7.96
Q3	16.15
95-th percentile	69.12
Maximum	499.99
Range	499.98
Interquartile range (IQR)	12.31

Descriptive statistics

Standard deviation	32.095211
Coefficient of variation (CV)	1.842249
Kurtosis	41.136902
Mean	17.421755
Median Absolute Deviation (MAD)	4.9
Skewness	5.3847201
Sum	10300491
Variance	1030.1025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	977	0.1%
3	931	0.1%
2.9	842	0.1%
2.8	836	0.1%
3.1	831	0.1%
2.1	786	0.1%
1.8	784	0.1%
1.5	783	0.1%
2.6	774	0.1%
2.85	762	0.1%
Other values (19877)	582937	82.4%
(Missing)	116632	16.5%

Value	Count	Frequency (%)
0.01	69	< 0.1%
0.02	91	< 0.1%
0.03	85	< 0.1%
0.04	57	< 0.1%
0.05	55	< 0.1%
0.06	60	< 0.1%
0.07	80	< 0.1%
0.08	72	< 0.1%
0.09	62	< 0.1%
0.1	178	< 0.1%

Value	Count	Frequency (%)
499.99	1	< 0.1%
499.52	1	< 0.1%
498.97	1	< 0.1%
498.57	1	< 0.1%
497.4	1	< 0.1%
496.23	1	< 0.1%
495.87	1	< 0.1%
494.9	1	< 0.1%
494.43	1	< 0.1%
494.09	1	< 0.1%

NO2
Real number (ℝ)

High correlation Missing

Distinct	18115
Distinct (%)	3.1%
Missing	117122
Missing (%)	16.5%
Infinite	0
Infinite (%)	0.0%
Mean	28.885157

Minimum	0.01
Maximum	499.51
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	3.73
Q1	10.81
median	20.32
Q3	36.35
95-th percentile	81.94
Maximum	499.51
Range	499.5
Interquartile range (IQR)	25.54

Descriptive statistics

Standard deviation	29.162194
Coefficient of variation (CV)	1.009591
Kurtosis	20.679073
Mean	28.885157
Median Absolute Deviation (MAD)	10.93
Skewness	3.3431675
Sum	17063993
Variance	850.43359
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.5	532	0.1%
7	374	0.1%
10	364	0.1%
10.12	355	0.1%
9.2	335	< 0.1%
9.88	334	< 0.1%
9.12	328	< 0.1%
8.8	325	< 0.1%
9	324	< 0.1%
10.18	316	< 0.1%
Other values (18105)	587166	82.9%
(Missing)	117122	16.5%

Value	Count	Frequency (%)
0.01	50	< 0.1%
0.02	193	< 0.1%
0.03	252	< 0.1%
0.04	192	< 0.1%
0.05	170	< 0.1%
0.06	181	< 0.1%
0.07	178	< 0.1%
0.08	168	< 0.1%
0.09	130	< 0.1%
0.1	199	< 0.1%

Value	Count	Frequency (%)
499.51	1	< 0.1%
495.56	1	< 0.1%
494.15	1	< 0.1%
493.42	1	< 0.1%
485.46	1	< 0.1%
485.16	1	< 0.1%
482.15	1	< 0.1%
478.23	1	< 0.1%
478.2	1	< 0.1%
477.37	1	< 0.1%

NOx
Real number (ℝ)

High correlation Missing Zeros

Distinct	23602
Distinct (%)	4.0%
Missing	123224
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	32.287565

Minimum	0
Maximum	498.61
Zeros	19811
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1.58
Q1	10.66
median	20.79
Q3	37.15
95-th percentile	105.59
Maximum	498.61
Range	498.61
Interquartile range (IQR)	26.49

Descriptive statistics

Standard deviation	39.756669
Coefficient of variation (CV)	1.2313307
Kurtosis	20.452373
Mean	32.287565
Median Absolute Deviation (MAD)	12
Skewness	3.6879741
Sum	18876957
Variance	1580.5927
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19811	2.8%
4.22	9936	1.4%
6.24	3440	0.5%
2.21	1495	0.2%
5	832	0.1%
4.9	724	0.1%
6.9	375	0.1%
7	344	< 0.1%
9	332	< 0.1%
8.9	322	< 0.1%
Other values (23592)	547040	77.3%
(Missing)	123224	17.4%

Value	Count	Frequency (%)
0	19811	2.8%
0.01	29	< 0.1%
0.02	47	< 0.1%
0.03	105	< 0.1%
0.04	48	< 0.1%
0.05	65	< 0.1%
0.06	15	< 0.1%
0.07	30	< 0.1%
0.08	35	< 0.1%
0.09	20	< 0.1%

Value	Count	Frequency (%)
498.61	1	< 0.1%
498.29	1	< 0.1%
496.29	1	< 0.1%
496	1	< 0.1%
494.73	1	< 0.1%
494.54	1	< 0.1%
493.73	1	< 0.1%
493.4	1	< 0.1%
493.13	1	< 0.1%
492.84	1	< 0.1%

NH3
Real number (ℝ)

Missing

Distinct	16426
Distinct (%)	3.8%
Missing	272542
Missing (%)	38.5%
Infinite	0
Infinite (%)	0.0%
Mean	23.607959

Minimum	0.01
Maximum	499.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	2.57
Q1	8.12
median	15.38
Q3	29.23
95-th percentile	65.63
Maximum	499.97
Range	499.96
Interquartile range (IQR)	21.11

Descriptive statistics

Standard deviation	28.8319
Coefficient of variation (CV)	1.2212788
Kurtosis	47.56148
Mean	23.607959
Median Absolute Deviation (MAD)	8.92
Skewness	5.2440197
Sum	10277323
Variance	831.27846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	868	0.1%
2.5	511	0.1%
5	449	0.1%
6.5	436	0.1%
6.38	431	0.1%
6.25	416	0.1%
6.33	404	0.1%
6.4	387	0.1%
6.62	384	0.1%
6.6	377	0.1%
Other values (16416)	430670	60.8%
(Missing)	272542	38.5%

Value	Count	Frequency (%)
0.01	71	< 0.1%
0.02	64	< 0.1%
0.03	93	< 0.1%
0.04	39	< 0.1%
0.05	113	< 0.1%
0.06	31	< 0.1%
0.07	29	< 0.1%
0.08	105	< 0.1%
0.09	13	< 0.1%
0.1	205	< 0.1%

Value	Count	Frequency (%)
499.97	1	< 0.1%
499.56	1	< 0.1%
499.12	1	< 0.1%
498.54	1	< 0.1%
497.99	1	< 0.1%
497.95	1	< 0.1%
497.88	1	< 0.1%
497.38	1	< 0.1%
495.23	1	< 0.1%
493.6	1	< 0.1%

CO
Real number (ℝ)

Missing Skewed Zeros

Distinct	7017
Distinct (%)	1.1%
Missing	86517
Missing (%)	12.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.1835393

Minimum	0
Maximum	498.57
Zeros	66088
Zeros (%)	9.3%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.42
median	0.8
Q3	1.37
95-th percentile	6.18
Maximum	498.57
Range	498.57
Interquartile range (IQR)	0.95

Descriptive statistics

Standard deviation	10.970514
Coefficient of variation (CV)	5.0241892
Kurtosis	586.31918
Mean	2.1835393
Median Absolute Deviation (MAD)	0.44
Skewness	20.852959
Sum	1356759.6
Variance	120.35219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	66088	9.3%
0.62	4650	0.7%
0.64	4635	0.7%
0.7	4595	0.6%
0.52	4574	0.6%
0.66	4530	0.6%
0.68	4522	0.6%
0.6	4507	0.6%
0.48	4445	0.6%
0.72	4445	0.6%
Other values (7007)	514367	72.7%
(Missing)	86517	12.2%

Value	Count	Frequency (%)
0	66088	9.3%
0.01	905	0.1%
0.02	553	0.1%
0.03	599	0.1%
0.04	680	0.1%
0.05	826	0.1%
0.06	702	0.1%
0.07	636	0.1%
0.08	995	0.1%
0.09	669	0.1%

Value	Count	Frequency (%)
498.57	1	< 0.1%
494.9	1	< 0.1%
490.35	1	< 0.1%
485.73	1	< 0.1%
483.37	1	< 0.1%
476.2	1	< 0.1%
476.02	1	< 0.1%
475.4	1	< 0.1%
473.81	1	< 0.1%
470.72	1	< 0.1%

SO2
Real number (ℝ)

Missing

Distinct	14145
Distinct (%)	2.4%
Missing	130373
Missing (%)	18.4%
Infinite	0
Infinite (%)	0.0%
Mean	14.038307

Minimum	0.01
Maximum	199.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	1.83
Q1	4.88
median	8.37
Q3	14.78
95-th percentile	45.62
Maximum	199.96
Range	199.95
Interquartile range (IQR)	9.9

Descriptive statistics

Standard deviation	19.30554
Coefficient of variation (CV)	1.3752042
Kurtosis	26.105521
Mean	14.038307
Median Absolute Deviation (MAD)	4.27
Skewness	4.4367951
Sum	8107150.6
Variance	372.70386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.5	679	0.1%
5.4	664	0.1%
4	651	0.1%
5	651	0.1%
5.62	648	0.1%
6	641	0.1%
4.5	639	0.1%
6.3	624	0.1%
6.1	616	0.1%
4.38	612	0.1%
Other values (14135)	571077	80.7%
(Missing)	130373	18.4%

Value	Count	Frequency (%)
0.01	49	< 0.1%
0.02	110	< 0.1%
0.03	102	< 0.1%
0.04	81	< 0.1%
0.05	79	< 0.1%
0.06	76	< 0.1%
0.07	63	< 0.1%
0.08	76	< 0.1%
0.09	66	< 0.1%
0.1	378	0.1%

Value	Count	Frequency (%)
199.96	2	< 0.1%
199.95	1	< 0.1%
199.93	1	< 0.1%
199.85	1	< 0.1%
199.81	1	< 0.1%
199.77	1	< 0.1%
199.75	1	< 0.1%
199.72	1	< 0.1%
199.7	1	< 0.1%
199.65	1	< 0.1%

O3
Real number (ℝ)

Missing

Distinct	16909
Distinct (%)	2.9%
Missing	129208
Missing (%)	18.3%
Infinite	0
Infinite (%)	0.0%
Mean	34.798979

Minimum	0.01
Maximum	497.62
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0.01
5-th percentile	3.79
Q1	13.42
median	26.24
Q3	47.62
95-th percentile	94.65
Maximum	497.62
Range	497.61
Interquartile range (IQR)	34.2

Descriptive statistics

Standard deviation	29.806379
Coefficient of variation (CV)	0.85653027
Kurtosis	4.3715225
Mean	34.798979
Median Absolute Deviation (MAD)	15.41
Skewness	1.6935193
Sum	20137021
Variance	888.42023
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.48	424	0.1%
17	404	0.1%
22.14	373	0.1%
3	347	< 0.1%
43.02	334	< 0.1%
43.77	323	< 0.1%
9.8	291	< 0.1%
0.1	290	< 0.1%
7.8	263	< 0.1%
19.6	257	< 0.1%
Other values (16899)	575361	81.3%
(Missing)	129208	18.3%

Value	Count	Frequency (%)
0.01	48	< 0.1%
0.02	97	< 0.1%
0.03	62	< 0.1%
0.04	54	< 0.1%
0.05	55	< 0.1%
0.06	42	< 0.1%
0.07	52	< 0.1%
0.08	43	< 0.1%
0.09	43	< 0.1%
0.1	290	< 0.1%

Value	Count	Frequency (%)
497.62	1	< 0.1%
474.58	1	< 0.1%
474.2	1	< 0.1%
471.12	1	< 0.1%
440	1	< 0.1%
424.42	1	< 0.1%
419.71	1	< 0.1%
388.79	1	< 0.1%
382.92	1	< 0.1%
368.08	1	< 0.1%

Benzene
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	6073
Distinct (%)	1.1%
Missing	163646
Missing (%)	23.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.087595

Minimum	0
Maximum	498.07
Zeros	118727
Zeros (%)	16.8%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.05
median	0.86
Q3	2.75
95-th percentile	9.49
Maximum	498.07
Range	498.07
Interquartile range (IQR)	2.7

Descriptive statistics

Standard deviation	16.456599
Coefficient of variation (CV)	5.3299085
Kurtosis	573.29287
Mean	3.087595
Median Absolute Deviation (MAD)	0.86
Skewness	22.511603
Sum	1680358.7
Variance	270.81964
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	118727	16.8%
0.1	7408	1.0%
0.03	4442	0.6%
0.35	3699	0.5%
0.2	3697	0.5%
0.04	3567	0.5%
0.01	3502	0.5%
0.05	3461	0.5%
0.02	3356	0.5%
0.08	3038	0.4%
Other values (6063)	389332	55.0%
(Missing)	163646	23.1%

Value	Count	Frequency (%)
0	118727	16.8%
0.01	3502	0.5%
0.02	3356	0.5%
0.03	4442	0.6%
0.04	3567	0.5%
0.05	3461	0.5%
0.06	2108	0.3%
0.07	2211	0.3%
0.08	3038	0.4%
0.09	1958	0.3%

Value	Count	Frequency (%)
498.07	4	< 0.1%
491.51	8	< 0.1%
488.48	1	< 0.1%
487.79	1	< 0.1%
487.21	1	< 0.1%
487.2	1	< 0.1%
486.58	1	< 0.1%
485.69	1	< 0.1%
485.44	2	< 0.1%
485.21	2	< 0.1%

Toluene
Real number (ℝ)

High correlation Missing Zeros

Distinct	10383
Distinct (%)	2.1%
Missing	220607
Missing (%)	31.2%
Infinite	0
Infinite (%)	0.0%
Mean	8.6609266

Minimum	0
Maximum	499.4
Zeros	89705
Zeros (%)	12.7%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.37
median	2.59
Q3	8.41
95-th percentile	35.21
Maximum	499.4
Range	499.4
Interquartile range (IQR)	8.04

Descriptive statistics

Standard deviation	21.741023
Coefficient of variation (CV)	2.5102422
Kurtosis	200.96317
Mean	8.6609266
Median Absolute Deviation (MAD)	2.59
Skewness	11.494659
Sum	4220192.4
Variance	472.6721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	89705	12.7%
1.1	2589	0.4%
0.1	2452	0.3%
0.2	1899	0.3%
0.3	1315	0.2%
0.03	1233	0.2%
80.04	1155	0.2%
0.5	1145	0.2%
0.08	1133	0.2%
0.18	1122	0.2%
Other values (10373)	383520	54.2%
(Missing)	220607	31.2%

Value	Count	Frequency (%)
0	89705	12.7%
0.01	418	0.1%
0.02	561	0.1%
0.03	1233	0.2%
0.04	760	0.1%
0.05	942	0.1%
0.06	781	0.1%
0.07	960	0.1%
0.08	1133	0.2%
0.09	559	0.1%

Value	Count	Frequency (%)
499.4	1	< 0.1%
498.07	4	< 0.1%
491.6	1	< 0.1%
491.51	5	< 0.1%
488.53	1	< 0.1%
488.48	1	< 0.1%
487.79	1	< 0.1%
487.21	1	< 0.1%
487.2	1	< 0.1%
486.58	1	< 0.1%

Xylene
Real number (ℝ)

High correlation Missing Zeros

Distinct	4340
Distinct (%)	1.7%
Missing	455829
Missing (%)	64.4%
Infinite	0
Infinite (%)	0.0%
Mean	3.1305368

Minimum	0
Maximum	499.99
Zeros	49350
Zeros (%)	7.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1
median	0.79
Q3	3.12
95-th percentile	13.32
Maximum	499.99
Range	499.99
Interquartile range (IQR)	3.02

Descriptive statistics

Standard deviation	7.8348316
Coefficient of variation (CV)	2.5027119
Kurtosis	419.4058
Mean	3.1305368
Median Absolute Deviation (MAD)	0.79
Skewness	13.693196
Sum	789039.28
Variance	61.384586
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	49350	7.0%
2	5962	0.8%
0.1	5478	0.8%
0.65	4119	0.6%
3.21	2653	0.4%
0.52	1940	0.3%
0.08	1935	0.3%
0.2	1694	0.2%
0.12	1634	0.2%
0.05	1579	0.2%
Other values (4330)	175702	24.8%
(Missing)	455829	64.4%

Value	Count	Frequency (%)
0	49350	7.0%
0.01	1042	0.1%
0.02	1471	0.2%
0.03	1432	0.2%
0.04	1147	0.2%
0.05	1579	0.2%
0.06	1452	0.2%
0.07	1502	0.2%
0.08	1935	0.3%
0.09	1490	0.2%

Value	Count	Frequency (%)
499.99	1	< 0.1%
461.39	1	< 0.1%
433.94	1	< 0.1%
402.64	1	< 0.1%
396.06	1	< 0.1%
347.1	1	< 0.1%
327.16	1	< 0.1%
319.95	1	< 0.1%
278.69	1	< 0.1%
277.18	1	< 0.1%

AQI
Real number (ℝ)

High correlation Missing

Distinct	1556
Distinct (%)	0.3%
Missing	129080
Missing (%)	18.2%
Infinite	0
Infinite (%)	0.0%
Mean	166.4135

Minimum	8
Maximum	3133
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 MiB

Quantile statistics

Minimum	8
5-th percentile	46
Q1	79
median	116
Q3	208
95-th percentile	397
Maximum	3133
Range	3125
Interquartile range (IQR)	129

Descriptive statistics

Standard deviation	162.11273
Coefficient of variation (CV)	0.97415611
Kurtosis	75.439063
Mean	166.4135
Median Absolute Deviation (MAD)	49
Skewness	6.3813666
Sum	96319302
Variance	26280.537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102	5371	0.8%
68	5021	0.7%
104	4984	0.7%
78	4928	0.7%
106	4848	0.7%
72	4817	0.7%
66	4813	0.7%
100	4812	0.7%
80	4775	0.7%
70	4736	0.7%
Other values (1546)	529690	74.8%
(Missing)	129080	18.2%

Value	Count	Frequency (%)
8	1	< 0.1%
9	8	< 0.1%
10	21	< 0.1%
11	53	< 0.1%
12	41	< 0.1%
13	35	< 0.1%
14	29	< 0.1%
15	49	< 0.1%
16	54	< 0.1%
17	54	< 0.1%

Value	Count	Frequency (%)
3133	8	< 0.1%
3111	8	< 0.1%
3084	8	< 0.1%
3057	8	< 0.1%
3043	8	< 0.1%
3001	8	< 0.1%
3000	8	< 0.1%
2996	8	< 0.1%
2987	8	< 0.1%
2969	8	< 0.1%

AQI_Bucket
Categorical

Missing

Distinct	6
Distinct (%)	< 0.1%
Missing	129080
Missing (%)	18.2%
Memory size	5.4 MiB

Moderate	198991
Satisfactory	189434
Poor	66654
Very Poor	57455
Good	38611

Length

Max length	12
Median length	9
Mean length	8.5854076
Min length	4

Characters and Unicode

Total characters	4969191
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Poor
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Moderate	198991	28.1%
Satisfactory	189434	26.8%
Poor	66654	9.4%
Very Poor	57455	8.1%
Good	38611	5.5%
Severe	27650	3.9%
(Missing)	129080	18.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
moderate	198991	31.3%
satisfactory	189434	29.8%
poor	124109	19.5%
very	57455	9.0%
good	38611	6.1%
severe	27650	4.3%

Most occurring characters

Value	Count	Frequency (%)
o	713865	14.4%
r	597639	12.0%
t	577859	11.6%
a	577859	11.6%
e	538387	10.8%
y	246889	5.0%
d	237602	4.8%
S	217084	4.4%
M	198991	4.0%
i	189434	3.8%
Other values (8)	873582	17.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4969191	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	713865	14.4%
r	597639	12.0%
t	577859	11.6%
a	577859	11.6%
e	538387	10.8%
y	246889	5.0%
d	237602	4.8%
S	217084	4.4%
M	198991	4.0%
i	189434	3.8%
Other values (8)	873582	17.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4969191	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	713865	14.4%
r	597639	12.0%
t	577859	11.6%
a	577859	11.6%
e	538387	10.8%
y	246889	5.0%
d	237602	4.8%
S	217084	4.4%
M	198991	4.0%
i	189434	3.8%
Other values (8)	873582	17.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4969191	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	713865	14.4%
r	597639	12.0%
t	577859	11.6%
a	577859	11.6%
e	538387	10.8%
y	246889	5.0%
d	237602	4.8%
S	217084	4.4%
M	198991	4.0%
i	189434	3.8%
Other values (8)	873582	17.6%

	AQI	AQI_Bucket	Benzene	CO	City	NH3	NO	NO2	NOx	O3	PM10	PM2.5	SO2	Toluene	Xylene
AQI	1.000	0.428	0.259	0.456	0.189	0.355	0.351	0.418	0.409	0.160	0.782	0.753	0.323	0.351	0.125
AQI_Bucket	0.428	1.000	0.035	0.144	0.343	0.124	0.133	0.181	0.172	0.119	0.393	0.340	0.156	0.099	0.034
Benzene	0.259	0.035	1.000	0.291	0.094	0.137	0.241	0.355	0.296	0.054	0.348	0.256	0.155	0.790	0.721
CO	0.456	0.144	0.291	1.000	0.100	0.210	0.340	0.302	0.356	-0.064	0.314	0.347	0.267	0.402	0.391
City	0.189	0.343	0.094	0.100	1.000	0.167	0.116	0.140	0.135	0.090	0.191	0.150	0.228	0.117	0.026
NH3	0.355	0.124	0.137	0.210	0.167	1.000	0.316	0.471	0.339	0.127	0.371	0.365	0.103	0.116	-0.120
NO	0.351	0.133	0.241	0.340	0.116	0.316	1.000	0.423	0.725	-0.245	0.423	0.340	0.266	0.218	0.250
NO2	0.418	0.181	0.355	0.302	0.140	0.471	0.423	1.000	0.670	0.084	0.502	0.435	0.225	0.414	0.238
NOx	0.409	0.172	0.296	0.356	0.135	0.339	0.725	0.670	1.000	-0.134	0.502	0.393	0.284	0.321	0.253
O3	0.160	0.119	0.054	-0.064	0.090	0.127	-0.245	0.084	-0.134	1.000	0.127	0.087	0.105	0.094	-0.045
PM10	0.782	0.393	0.348	0.314	0.191	0.371	0.423	0.502	0.502	0.127	1.000	0.857	0.343	0.409	0.168
PM2.5	0.753	0.340	0.256	0.347	0.150	0.365	0.340	0.435	0.393	0.087	0.857	1.000	0.241	0.292	0.201
SO2	0.323	0.156	0.155	0.267	0.228	0.103	0.266	0.225	0.284	0.105	0.343	0.241	1.000	0.295	0.260
Toluene	0.351	0.099	0.790	0.402	0.117	0.116	0.218	0.414	0.321	0.094	0.409	0.292	0.295	1.000	0.620
Xylene	0.125	0.034	0.721	0.391	0.026	-0.120	0.250	0.238	0.253	-0.045	0.168	0.201	0.260	0.620	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	City	Datetime	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	AQI	AQI_Bucket
0	Ahmedabad	2015-01-01 01:00:00	NaN	NaN	1.00	40.01	36.37	NaN	1.00	122.07	NaN	NaN	NaN
1	Ahmedabad	2015-01-01 02:00:00	NaN	NaN	0.02	27.75	19.73	NaN	0.02	85.90	NaN	NaN	NaN
2	Ahmedabad	2015-01-01 03:00:00	NaN	NaN	0.08	19.32	11.08	NaN	0.08	52.83	NaN	NaN	NaN
3	Ahmedabad	2015-01-01 04:00:00	NaN	NaN	0.30	16.45	9.20	NaN	0.30	39.53	153.58	NaN	NaN
4	Ahmedabad	2015-01-01 05:00:00	NaN	NaN	0.12	14.90	7.85	NaN	0.12	32.63	NaN	NaN	NaN
5	Ahmedabad	2015-01-01 06:00:00	NaN	NaN	0.33	15.95	10.82	NaN	0.33	29.87	64.25	NaN	NaN
6	Ahmedabad	2015-01-01 07:00:00	NaN	NaN	0.45	15.94	12.47	NaN	0.45	27.41	191.96	NaN	NaN
7	Ahmedabad	2015-01-01 08:00:00	NaN	NaN	1.03	16.66	16.48	NaN	1.03	20.92	177.21	NaN	NaN
8	Ahmedabad	2015-01-01 09:00:00	NaN	NaN	1.47	16.25	18.02	NaN	1.47	16.45	122.08	NaN	NaN
9	Ahmedabad	2015-01-01 10:00:00	NaN	NaN	2.05	13.78	16.08	NaN	2.05	15.14	NaN	NaN	NaN

	City	Datetime	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
707865	Visakhapatnam	2020-06-30 15:00:00	15.75	30.25	0.95	13.75	8.07	4.67	0.30	2.90	41.55	0.0	0.0	0.0	51.0	Satisfactory
707866	Visakhapatnam	2020-06-30 16:00:00	14.00	29.50	1.77	20.70	12.45	8.08	0.45	7.12	39.23	0.0	0.0	0.0	51.0	Satisfactory
707867	Visakhapatnam	2020-06-30 17:00:00	9.75	24.25	2.88	23.85	15.02	12.23	0.57	8.45	34.78	0.0	0.0	0.0	51.0	Satisfactory
707868	Visakhapatnam	2020-06-30 18:00:00	6.50	24.75	2.25	23.38	13.68	10.60	0.66	5.80	33.55	NaN	NaN	NaN	51.0	Satisfactory
707869	Visakhapatnam	2020-06-30 19:00:00	8.25	33.25	0.35	24.05	13.05	5.55	0.44	1.85	41.38	NaN	NaN	NaN	51.0	Satisfactory
707870	Visakhapatnam	2020-06-30 20:00:00	9.50	36.00	2.75	25.57	15.85	4.57	0.62	NaN	27.75	NaN	NaN	NaN	51.0	Satisfactory
707871	Visakhapatnam	2020-06-30 21:00:00	17.25	49.25	3.62	33.20	20.62	3.78	0.76	2.02	25.58	NaN	NaN	NaN	51.0	Satisfactory
707872	Visakhapatnam	2020-06-30 22:00:00	36.00	71.00	2.20	30.80	18.20	3.67	0.58	1.77	26.15	NaN	NaN	NaN	50.0	Good
707873	Visakhapatnam	2020-06-30 23:00:00	15.75	63.00	1.02	28.90	16.00	3.80	0.49	0.75	15.82	NaN	NaN	NaN	50.0	Good
707874	Visakhapatnam	2020-07-01 00:00:00	15.00	66.00	0.40	26.85	14.05	5.20	0.59	2.10	17.05	NaN	NaN	NaN	50.0	Good

Overview

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample